package liuyuyang.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import liuyuyang.domain.Course;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CourseMapper extends BaseMapper<Course> {
    @Select("select c.* from tb_course c, tb_student_course sc where c.c_id = sc.c_id && sc.s_id = #{id}")
    public List<Course> get(Integer id);
}